﻿PRINT 'Server instance'
EXEC sp_configure 'show advanced options',1;RECONFIGURE
EXEC sp_configure 'clr enabled',1;RECONFIGURE
PRINT 'Database'
BEGIN TRY USE bigorm;ALTER DATABASE bigorm SET READ_ONLY WITH ROLLBACK IMMEDIATE END TRY BEGIN CATCH END CATCH
USE master;
BEGIN TRY DROP DATABASE bigorm END TRY BEGIN CATCH END CATCH
CREATE DATABASE bigorm
GO
ALTER DATABASE bigorm SET TRUSTWORTHY ON
USE bigorm
GO
BEGIN TRY EXEC ('CREATE SCHEMA bigorm') END TRY BEGIN CATCH END CATCH --BEGIN TRY EXEC ('CREATE SCHEMA vogorm') END TRY BEGIN CATCH END CATCH--BEGIN TRY EXEC ('CREATE SCHEMA vagorm') END TRY BEGIN CATCH END CATCH--BEGIN TRY EXEC ('CREATE SCHEMA vegorm') END TRY BEGIN CATCH END CATCH--BEGIN TRY EXEC ('CREATE SCHEMA cogorm') END TRY BEGIN CATCH END CATCH
BEGIN TRY EXEC ('CREATE SCHEMA bigorm_test') END TRY BEGIN CATCH END CATCH
GO
--BEGIN TRY PRINT 'Drop old'--	DROP FUNCTION bigorm.HttpGet--	DROP FUNCTION bigorm_test.ZeroToNine--	DROP FUNCTION bigorm.GoogleAnalytics--	DROP FUNCTION bigorm.RawFileS--	DROP FUNCTION bigorm.RawFile--	DROP ASSEMBLY bigorm
--END TRY BEGIN CATCH END CATCH
GO
PRINT 'Create new'
CREATE ASSEMBLY bigorm --FROM 'C:\_customer_partner\bigorm\bigorm\bin\Debug\bigorm.dll' 
FROM 0x4D5A90000300000004000000FFFF0000B800000000000000400000000000000000000000000000000000000000000000000000000000000000000000800000000E1FBA0E00B409CD21B8014CCD21546869732070726F6772616D2063616E6E6F742062652072756E20696E20444F53206D6F64652E0D0D0A2400000000000000504500004C010300F031FE520000000000000000E00002210B010B00005A000000060000000000005E78000000200000008000000000001000200000000200000400000000000000040000000000000000C000000002000000000000030040850000100000100000000010000010000000000000100000000000000000000000107800004B00000000800000100300000000000000000000000000000000000000A000000C000000D87600001C0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000200000080000000000000000000000082000004800000000000000000000002E746578740000006458000000200000005A000000020000000000000000000000000000200000602E72737263000000100300000080000000040000005C0000000000000000000000000000400000402E72656C6F6300000C00000000A00000000200000060000000000000000000000000000040000042000000000000000000000000000000004078000000000000480000000200050038440000A03200000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000133004006402000001000011027B210000040B07450B000000310000000200000004000000090000000E00000013000000180000001D00000022000000270000002C0000002B312B66389200000038BE00000038EA00000038160100003842010000386E010000389701000038C101000038EC0100002B0538ED01000002157D210000040002166A7201000070720B00007073130000068C040000027D2000000402177D21000004170A38BF01000002157D2100000402176A7265000070726D00007073130000068C040000027D2000000402187D21000004170A388E01000002157D2100000402186A7283000070728B00007073130000068C040000027D2000000402197D21000004170A385D01000002157D2100000402196A7293000070729F00007073130000068C040000027D20000004021A7D21000004170A382C01000002157D21000004021A6A72A700007072B100007073130000068C040000027D20000004021B7D21000004170A38FB00000002157D21000004021B6A72EB00007072F500007073130000068C040000027D20000004021C7D21000004170A38CA00000002157D21000004021C6A7201010070720901007073130000068C040000027D20000004021D7D21000004170A389900000002157D21000004021D6A7219010070722501007073130000068C040000027D20000004021E7D21000004170A2B6B02157D21000004021E6A7225010070723101007073130000068C040000027D20000004021F097D21000004170A2B3C02157D21000004021F096A723F010070724901007073130000068C040000027D20000004021F0A7D21000004170A2B0C02157D2100000400160A2B00062A133001000B00000002000011027B200000040A2B00062A1A731A00000A7A0A002A000000133001000B00000002000011027B200000040A2B00062A3A02281B00000A02037D210000042A0000133001000D000000030000111673200000060A060B2B00072A0000001330020049000000040000110002A5040000020A0312007B02000004281C00000A81050000010412007B030000046F1D00000A281E00000A81060000010512007B040000046F1D00000A281E00000A81060000012A000000133002004B00000005000011282200000A6F2300000A027B24000004330F027B230000041FFEFE0116FE012B0117000C082D0B02167D23000004020A2B071673280000060A06027B260000047D25000004060B2B00072A00133001000B000000060000110228210000060A2B00062A001B300400C101000007000011027B230000040C0845040000000C0000000E00000002000000070000002B0C384F01000038810100002B05388201000002157D2300000400027B25000004726B0100706F2400000A6F2500000A16FE0216FE010D093A390100000002167D2700000402167D27000004027B250000041F2F6F2600000A0A2B6100027B250000046F2700000A061758FE0216FE010D092D3A00027B250000040617586F2800000A282900000A1F73FE0116FE010D092D0702177D2700000402027B2500000406186F2A00000A7D250000040000027B250000041F2F6F2600000A0A0615FE0116FE010D092D9402027B250000046F2B00000A7D2500000402027B25000004282C00000A7D2800000402027B25000004282D00000A7D290000040002027B28000004027B29000004027B270000042D03162B011700282E00000A6F1F00000A7D2B00000402177D230000042B2F02027B2B0000046F2100000A7D2A00000402027B2A0000047D2200000402187D23000004170BDE4B02177D23000004027B2B0000046F1500000A0D092DC202282900000600002B1E02027B250000047D2200000402197D23000004170BDE1402157D2300000400160BDE0802282600000600DC00072A000000411C00000400000000000000B6010000B60100000800000000000000133001000B00000008000011027B220000040A2B00062A1A731A00000A7A00001B3002002B00000009000011027B230000040B071759450200000004000000020000002B042B042B022B0BDE0802282900000600DC002A000110000002001F000221000800000000133001000B00000002000011027B220000040A2B00062A7A02281B00000A02037D2300000402282200000A6F2300000A7D240000042A000013300200210000000A00001102157D23000004027B2B00000414FE010A062D0C027B2B0000046F0100000A002A00000013300200150000000B0000111FFE73280000060A06027D26000004060B2B00072A0000001B300400CB0300000C000011027B2D0000040B0745070000001100000013000000130000000200000013000000070000000C0000002B113870010000389E02000038600300002B05387B03000002157D2D00000400027C32000004176A7D050000040002027B2E00000428030000066F1F00000A7D3A00000402177D2D000004382903000002027B3A0000046F2100000A7D3300000400027C32000004732F00000A7D08000004027C32000004027B330000047D0700000402027B33000004733000000A283100000A7D34000004027C32000004027B300000047D06000004027C320000047B06000004156AFE0116FE010C082D14027C3200000421FFFFFFFFFFFFFF3F7D06000004027B34000004027B2F000004027C320000047B0600000458FE0216FE010C082D1802027B2F000004027C320000047B06000004587D3400000402147D350000040002027B3300000419283200000A7D3500000400DE05260000DE0000027B3500000414FE0116FE010C082D5B00027C32000004027C320000047B05000004657D0500000402027B320000048C050000027D2C00000402197D2D000004170ADD2802000002177D2D000004027C32000004027C320000047B05000004657D050000040038A00100000002027B2F0000047D36000004386C01000000027B36000004027B3100000458027B34000004FE040C082D1302027B34000004027B36000004597D31000004027B31000004166AFE0216FE010C083A1701000002027B35000004027B36000004027B310000046F3300000A7D37000004021A7D2D0000040002166A7D3900000438C800000000027B37000004027B39000004027C380000046F0100002B00027B380000041F20FE040C082D17027C320000047B08000004027B380000046F3500000A26027B380000041F0D2E1C027C320000047B080000046F3600000A20A00F0000FE0116FE012B0116000C082D4E0002027B320000048C050000027D2C000004021B7D2D000004170ADDF5000000021A7D2D000004027C320000047B08000004166F3700000A00027C32000004257B05000004176A587D05000004000002257B39000004176A587D39000004027B39000004027B31000004FE040C083A23FFFFFF00022831000006000002257B36000004027B31000004587D36000004027B36000004027B34000004FE040C083A7FFEFFFF027B350000046F3800000A0000027C320000047B080000046F3600000A16FE0216FE010C082D2302027B320000048C050000027D2C000004021C7D2D000004170ADE2E02177D2D00000400027B3A0000046F1500000A0C083AC5FCFFFF0228300000060000160ADE0802282D00000600DC00062A0041340000000000003D010000160000005301000005000000300000010400000000000000C0030000C00300000800000000000000133001000B00000002000011027B2C0000040A2B00062A1A731A00000A7A00001B3002006B0000000D000011027B2D0000040A06175945060000000A0000000C000000020000000600000004000000080000002B0A2B0A2B082B062B042B022B35027B2D0000040A061A59450200000004000000020000002B042B042B022B0BDE0802283100000600DC00DE0802283000000600DC002A00011C0000020054000256000800000000020035002C61000800000000133001000B00000002000011027B2C0000040A2B00062A3A02281B00000A02037D2D0000042A000013300200210000000A00001102157D2D000004027B3A00000414FE010A062D0C027B3A0000046F0100000A002A00000013300200210000000A00001102177D2D000004027B3700000414FE010A062D0C027B370000046F0100000A002A00000013300200290000000E00001116732F0000060A06027D2E00000406037D2F00000406047D3000000406057D31000004060B2B00072A00000013300200290000000F0000110002A5050000020A0312007B05000004550412007B07000004510512007B080000046F1D00000A512A0000001B300400490300000C000011027B3C0000040B07162E200719594503000000020000000E000000070000002B0C385001000038730200002B05380803000002157D3C00000400027C41000004176A7D090000040002027B3D00000428030000066F1F00000A7D4800000402177D3C00000438B602000002027B480000046F2100000A7D4200000400027C41000004027B420000047D0A00000402027B42000004733000000A283100000A7D43000004027C41000004027B3F0000047D0C000004027C410000047B0C00000416FE0116FE010C082D19027C41000004027B43000004027B3E00000459697D0C000004027B43000004027B3E000004FE0216FE010C083A250200000002147D440000040002027B4200000419283200000A7D4400000400DE05260000DE0000027C41000004168D310000017D0B000004027B4400000414FE0116FE010C082D5B00027C41000004027C410000047B09000004657D0900000402027B410000048C060000027D3B00000402197D3C000004170ADDD001000002177D3C000004027C41000004027C410000047B09000004657D090000040038840100000002027B3E0000047D4500000402166A7D46000004383601000000027B45000004027C410000047B0C0000046A58027B43000004FE040C082D19027C41000004027B43000004027B4500000459697D0C00000402027B44000004027B45000004027C410000047B0C0000046A6F3300000A7D47000004021A7D3C00000400027C410000047B0B0000042C1C027C410000047B0B0000048E69027C410000047B0C000004FE012B0116000C082D1B027C41000004027C410000047B0C0000048D310000017D0B000004027C41000004027B47000004027C410000047B0C00000428070000060002027B410000048C060000027D3B000004021B7D3C000004170ADDA8000000021A7D3C000004027C41000004257B09000004176A587D0900000400022839000006000002257B45000004027C410000047B0C0000046A587D4500000402257B46000004176A587D46000004027B45000004027B430000042F10027B46000004027B40000004FE042B0116000C083AA3FEFFFF027B440000046F3800000A00000000027B480000046F1500000A0C083A38FDFFFF0228380000060000160ADE0802283500000600DC00062A0000004134000000000000020100001600000018010000050000003000000104000000000000003E0300003E0300000800000000000000133001000B00000002000011027B3B0000040A2B00062A1A731A00000A7A00001B300200650000000D000011027B3C0000040A0617594505000000080000000A0000000200000006000000040000002B082B082B062B042B022B35027B3C0000040A061A59450200000004000000020000002B042B042B022B0BDE0802283900000600DC00DE0802283800000600DC002A000000011C000002004E00025000080000000002002F002C5B000800000000133001000B00000002000011027B3B0000040A2B00062A3A02281B00000A02037D3C0000042A000013300200210000000A00001102157D3C000004027B4800000414FE010A062D0C027B480000046F0100000A002A00000013300200210000000A00001102177D3C000004027B4700000414FE010A062D0C027B470000046F0100000A002A0000001330020029000000100000111673370000060A06027D3D00000406037D3E00000406047D3F00000406057D40000004060B2B00072A0000001330040039000000110000110016D30A036F3900000A12006F3A00000A0006733B00000A16283C00000A027B0B0000041604283D00000A00036F3900000A6F3E00000A002A000000133002002D000000120000110002A5060000020A0312007B09000004550512007B0B000004733F00000A81090000010412007B0A000004512A000000133002004B00000013000011282200000A6F2300000A027B4B000004330F027B4A0000041FFEFE0116FE012B0117000C082D0B02167D4A000004020A2B071673410000060A06027B4D0000047D4C000004060B2B00072A00133001000B0000000600001102283A0000060A2B00062A001B300300E40000000C000011027B4A0000040B0745030000000700000009000000020000002B0738840000002B0538AE00000002157D4A000004000002177D4A00000402027B4C00000472730100706F2400000A6F4000000A7D4F00000402167D500000042B5E02027B4F000004027B500000049A7D4E000004027B4E0000046F2B00000A6F2700000A16FE0216FE010C082D2302027B4E0000046F2B00000A7D4900000402187D4A000004170ADE3D02177D4A00000402027B5000000417587D50000004027B50000004027B4F0000048E69FE040C082D8E0228420000060000160ADE0802283F00000600DC00062A0110000004000000D9D9000800000000133001000B00000008000011027B490000040A2B00062A1A731A00000A7A000013300200270000000D000011027B4A0000040A061759450200000004000000020000002B042B042B022B07022842000006002A00133001000B00000002000011027B490000040A2B00062A7A02281B00000A02037D4A00000402282200000A6F2300000A7D4B0000042A2202157D4A0000042A001330020015000000140000111FFE73410000060A06027D4D000004060B2B00072A0000001B3006005F02000007000011027B520000040C0845030000000700000009000000020000002B0738EE0100002B05382902000002157D5200000400027C55000004176A7D0D0000040002027B5300000428090000066F1F00000A7D5C00000402177D5200000438D701000002027B5C0000046F2100000A7D5600000400027C55000004027B560000047D0E00000402027C550000047B0E000004284100000A74360000017D57000004027B570000041F646F4200000A00027B570000041F646F4300000A00027B57000004284400000A6F4500000A0002027B570000046F4600000A74370000017D58000004027C55000004027B580000046F4700000A697D10000004027C55000004027B580000046F4800000A7D0F00000402027B540000048D310000017D5900000402027B580000046F4900000A027B5900000416027B540000046F4A00000A7D5A00000402027B5A0000047D5B0000042B440002027B580000046F4900000A027B59000004027B5A000004027B54000004027B5A000004596F4A00000A7D5B00000402257B5A000004027B5B000004587D5A00000400027B5B000004163110027B5A000004027B54000004FE042B0116000D092D9D027C55000004027B5A0000048D310000017D11000004160A2B19027C550000047B1100000406027B5900000406919C0617580A06027B5A000004FE040D092DDA02027B550000048C070000027D5100000402187D52000004170BDE4E02177D52000004027B580000046F4B00000A00027C55000004257B0D000004176A587D0D00000400027B5C0000046F1500000A0D093A17FEFFFF0228490000060000160BDE0802284600000600DC00072A00411C0000040000000000000054020000540200000800000000000000133001000B00000002000011027B510000040A2B00062A1A731A00000A7A00001B3002002B00000009000011027B520000040B071759450200000004000000020000002B042B042B022B0BDE0802284900000600DC002A000110000002001F000221000800000000133001000B00000002000011027B510000040A2B00062A3A02281B00000A02037D520000042A000013300200210000000A00001102157D52000004027B5C00000414FE010A062D0C027B5C0000046F0100000A002A000000133002001B000000150000111673480000060A06027D5300000406037D54000004060B2B00072A001330020041000000160000110002A5070000020A0312007B0D000004550412007B0E000004510512007B0F000004510E0412007B10000004540E0512007B11000004733F00000A81090000012A00000013300400DC00000017000011027B5E0000040B0745030000000900000002000000040000002B092B7238AB0000002B0538AD00000002157D5E00000400027C5F000004284C00000A16FE010C082D5502727B010070188D060000010D09168F06000001027B62000004810600000109178F06000001027B6300000481060000010973140000068C080000027D5D00000402177D5E000004170A2B4B02157D5E0000042B3D00027C68000004FE1508000002027C6800000428150000060002027B680000048C080000027D5D00000402187D5E000004170A2B0D02157D5E0000040000160A2B00062A133001000B00000002000011027B5D0000040A2B00062A1A731A00000A7A0A002A000000133001000B00000002000011027B5D0000040A2B00062A3A02281B00000A02037D5E0000042A000013300200510000001800001116734F0000060A06027D5F00000406037D6000000406047D6100000406057D62000004060E047D63000004060E057D64000004060E067D65000004060E077D66000004060E087D67000004060B2B00072A0000001330030005030000190000110002A5080000020A0312007B1200000481060000010412007B15000004168F06000001710600000181060000010512007B14000004168F05000001710500000181050000010E0412007B13000004168F0A000001710A000001810A0000010E0512007B15000004178F06000001710600000181060000010E0612007B14000004178F05000001710500000181050000010E0712007B13000004178F0A000001710A000001810A0000010E0812007B15000004188F06000001710600000181060000010E0912007B14000004188F05000001710500000181050000010E0A12007B13000004188F0A000001710A000001810A0000010E0B12007B15000004198F06000001710600000181060000010E0C12007B14000004198F05000001710500000181050000010E0D12007B13000004198F0A000001710A000001810A0000010E0E12007B150000041A8F06000001710600000181060000010E0F12007B140000041A8F05000001710500000181050000010E1012007B130000041A8F0A000001710A000001810A0000010E1112007B150000041B8F06000001710600000181060000010E1212007B140000041B8F05000001710500000181050000010E1312007B130000041B8F0A000001710A000001810A0000010E1412007B150000041C8F06000001710600000181060000010E1512007B140000041C8F05000001710500000181050000010E1612007B130000041C8F0A000001710A000001810A0000010E1712007B150000041D8F06000001710600000181060000010E1812007B140000041D8F05000001710500000181050000010E1912007B130000041D8F0A000001710A000001810A0000010E1A12007B150000041E8F06000001710600000181060000010E1B12007B140000041E8F05000001710500000181050000010E1C12007B130000041E8F0A000001710A000001810A0000010E1D12007B150000041F098F06000001710600000181060000010E1E12007B140000041F098F05000001710500000181050000010E1F12007B130000041F098F0A000001710A000001810A0000012A0000001B300500950100001A000011000473170000060A067B1E00000416FE010D093A8900000073100000060B284E00000A1C8D270000011304110416728D010070A21104170F00284F00000AA211041872D1010070A21104190F01284C00000A2D1372D70100700F01284F00000A285000000A2B0572EB01007000A211041A7201020070A211041B066F1D00000AA21104285100000A6F5200000A00DE100714FE010D092D07076F0100000A00DC000F00284C00000A16FE010D092D2E73100000060B284E00000A28180000066F5200000A00DE100714FE010D092D07076F0100000A00DC0038B7000000067B1A00000416FE010D092D5300000F00284F00000A178D2800000113051105161F3B9D11056F4000000A13061613072B1F110611079A0C08281E00000A03066F1A000006280E00000600110717581307110711068E69FE040D092DD5002B57067B1B00000416FE010D092D2D0073100000060B284E00000A72190200706F5200000A00DE100714FE010D092D07076F0100000A00DC00002B1D0073100000060B0000DE100714FE010D092D07076F0100000A00DC00002A0000000134000002001E0072900010000000000200B50012C700100000000002005101126301100000000002007E0104820110000000001E02281B00000A2A2E021728110000060000002A133002002E0000000A00001102281B00000A0000027259020070735300000A7D010000040316FE010A062D0C027B010000046F5400000A00002A3A00027B010000046F5500000A002AA602FE15040000020002037D020000040204735700000A7D030000040205735700000A7D04000004002A0013300600F80200001B00001102FE1508000002000228150000060003727B010070285800000A16FE010C083ABB020000000204168F06000001FE16060000016F1D00000A72890200706F2400000A6F4000000A7D160000040204178F06000001FE16060000016F1D00000A72890200706F2400000A6F4000000A7D17000004728D020070735700000A0A160B381B02000000027B13000004078F0A0000017E5900000A810A000001027B14000004078F050000017E5A00000A810500000107027B160000048E69FE0416FE010C083ACD00000000027B15000004078F06000001027B16000004079A281E00000A81060000010672D3020070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F102007072F90200706F5B00000A6F5C00000A26067205030070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F1020070721F0300706F5B00000A6F5C00000A2606722B030070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F102007072450300706F5B00000A6F5C00000A2600380701000007027B160000048E69027B170000048E6958FE0416FE010C083AD300000000027B15000004078F06000001027B1700000407027B160000048E69599A281E00000A81060000010672D3020070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F102007072510300706F5B00000A6F5C00000A26067205030070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F102007072650300706F5B00000A6F5C00000A2606722B030070078C44000001027B15000004078F06000001FE16060000016F1D00000A72F102007072790300706F5B00000A6F5C00000A26002B16027B15000004078F060000017E5D00000A8106000001000717580B077E18000004FE040C083AD6FDFFFF06066F3600000A1859186F5E00000A2606728D0300706F5F00000A2602066F1D00000A281E00000A7D12000004002B17027B15000004168F0600000103281E00000A8106000001002A13300200950000001C00001100027E180000048D0A0000017D13000004027E180000048D050000017D14000004027E180000048D060000017D15000004027E5D00000A7D12000004160A2B4800027B13000004068F0A0000017E5900000A810A000001027B14000004068F050000017E5A00000A8105000001027B15000004068F060000017E5D00000A8106000001000617580A067E18000004FE040B072DAC2A221F0A80180000042A0000133003007F0000001D00001102281B00000A000002037D1F0000040F01286000000A2D090F01286100000A2B02166A000A0206176A5F176AFE017D190000040206186A5F186AFE017D1A00000402061A6A5F1A6AFE017D1B00000402061E6A5F1E6AFE017D1C00000402061F106A5F1F106AFE017D1D00000402061F206A5F1F206AFE017D1E000004002A00133001000B000000080000110072CD0300700A2B00062A00133003009B0000001E000011001F0C8D270000010B07167298060070A20717027C19000004286200000AA2071872AE060070A20719027C1A000004286200000AA2071A72E0060070A2071B027C1B000004286200000AA2071C7212070070A2071D027C1C000004286200000AA2071E7238070070A2071F09027C1D000004286200000AA2071F0A7268070070A2071F0B027C1E000004286200000AA207285100000A0A2B00062A0013300200350000001F00001100027C1F000004286000000A16FE010B072D09027B1F0000040A2B17027C1F000004286100000A1FFD6A5F736300000A0A2B00062A00000042534A4201000100000000000C00000076342E302E33303331390000000005006C000000C0120000237E00002C130000A811000023537472696E677300000000D42400009007000023555300642C0000100000002347554944000000742C00002C06000023426C6F6200000000000000020000015757A20B090A000000FA253300160000010000004700000010000000680000004F0000005B0000001A000000650000003C000000010000001F000000080000000F0000000F000000280000000300000001000000040000000E0000000100000000000A00010000000000060095008E0006009C008E000600A8008E000600C500B2000A00FD00E8000A000601E80006003B0120010E00A10185010A00CB01E8000A000602E8000A00570241020600A202960206000D04EE030600900576050600BB05A9050600D205A9050600EF05A90506000E06A90506002706A90506004006A90506005B06A90506007606A90506008F06EE030600A306EE030600B106A9050600CA06A90506000307E70606001F07E706060041072E077700550700000600840764070600A40764070A00E407C90706000A082001060042092E0706005A098E0006009309B2000600280B170B0600550B8E000600900B8E000600B30BA90B0600D50BA90B0600DF0BA90B0E00280C85010600A20CA90B0600AB0CA90B0600D60CA90B0600050D8E000600B10D8E000E00D20DB60D06000C0EEE030600260E8E000600310EEE031200DC0ED10E1200FA0ED10E12005C0FD10E1200B00FD10E1200C00FD10E1200F40FD10E06002E10A90B0A007A10C9070A009010C9070A009B10C9070A00D510C2101200FD10E71006000711EE0306001D11EE03060039118E0006005B118E0006006311640706008E117E1100000000010000000000010001000100100015000000050001000100030010001C0000000500010010000A011000310000000D00020013000A011000400000000D00050014000A0110004D0000000D00090014000A011000590000000D000D0014000A011000650000000D0012001400030010007900000005001900170003011000F9070000050020001B00030110007C09000005002200210003011000FB0B000005002C002A00030110000F0D000005003B003200030110004D0E0000050049003A0003011000AB0E0000050051004300030110004D10000005005D004A0001006502F7000600930200010600B00203010600B50203010600930200010600BD0200010600C4020E010600C70203010600930200010600CB020E010600D40211010600D60215010600930200010600E0020E010600E4020E010600F00215010600D40211010600FE02180106000A031C0106001003210106001603260106001C032B0106002D032B0116003B03150106004303370106004D03370106006303370106007903370106008903370106009E0337010100AF033A01010021089F010100A7081501010021080E010100A70815010100600A150106001A040E010600750A0E010600860A37010600970A0E010600A30A0E010600B80A0E010600C00AFA01010021089F010100A7081501060026040E010600300400010600BD02000106003704000106000A0C98020600140C0E0106001D0C00010600390C9C020600430C00010600560CA1020600660CA50206006F0C00010600780CFA01010021089F010100A70815010600C4020E0106003004000106003704150106004404000106001E0D0C030600290D0E0106003A0D00010600460D9C020600510D00010600640D00010600770DA1020600870DFA01010021080E010100A70815010100600A1501060059040E010600630E0E010600720E0E0106008D0E2B010600990E1501010021089F010100A7081501060059040E010600630415010600BA0E8C030600C50E0E010600EB0E900306000A0F950306001A0F11010600230F15010600320F15010600410FFA01010021089F010100A708150106007404180106007E04180106008804180106009104180106009D0418010600A604FC030600B204FC030600BC043A010600C8043A010600641000040C23000000009600D1000A000100282300000000960010010F000100AC2600000000910049011D000500182C0000000096005A0126000600502C00000000960063012F000A004C3100000000960071013A000E008431000000009100BA0143001200CC31000000009600D5014D0015000C34000000009100E2011D0019007837000000009600F10159001A00A037000000009600F90160001C0024390000000096001202700022008439000000009600220287002B00983C0000000096003702E9004B00703E0000000086183B02F3004E00783E0000000086183B02F3004E00843E0000000086183B02FB004E00BE3E00000000E1017002F3004F00CD3E0000000086183B0207014F00F83E0000000086183B022F015200FC410000000086003E03F30054009D4200000000911854116F045400A8420000000086183B023E0154003443000000009608BF03440155004C4300000000C600C90348015500F443000000008600D2034C015500502000000000E10118089B015500C02200000000E1092E08A2015500D72200000000E1017C08F3005500DE2200000000E1017002F3005500E42200000000E109B208A2015500FB220000000086183B0266015500802300000000E1019F09E2015600D82300000000E101F109F5015600F02300000000E10118089B015600DC2500000000E1091E0A48015600F32500000000E1017C08F3005600FC2500000000E1017002F3005600442600000000E109B208A20156005B260000000086183B02660156007C26000000008100CB0AF3005700D02600000000E10118089B015700DC2A00000000E1092E08A2015700F32A00000000E1017C08F3005700FC2A00000000E1017002F3005700902B00000000E109B208A2015700A72B0000000086183B0266015700B82B000000008100840CF3005800E82B000000008100930CF3005800882C00000000E10118089B015800143000000000E1092E08A20158002B3000000000E1017C08F3005800343000000000E1017002F3005800C43000000000E109B208A2015800DB300000000086183B0266015800EC30000000008100930DF30059001C31000000008100A20DF3005900083200000000E1019F09E2015900603200000000E101F109F5015900783200000000E10118089B015900783300000000E1091E0A480159008F3300000000E1017C08F3005900983300000000E1017002F3005900CC3300000000E109B208A2015900E3330000000086183B026601590002340000000081007E0EF3005A00303400000000E10118089B015A00B83600000000E1092E08A2015A00CF3600000000E1017C08F3005A00D83600000000E1017002F3005A00203700000000E109B208A2015A0037370000000086183B0266015A0048370000000081004D0FF3005B00F03700000000E10118089B015B00D83800000000E1092E08A2015B00EF3800000000E1017C08F3005B00F63800000000E1017002F3005B00FC3800000000E109B208A2015B0013390000000086183B0266015B0000000100EA0302000200930202000300B00202000400B502000001001A0400000100260400000200300400000300BD0200000400370400000100EA0302000200930202000300C40202000400C70200000100C40200000200300400000300370400000400440400000100EA0300000200500400000300370400000100EA0302000200930202000300CB0202000400D40200000100590400000100590400000200630400000100EA0302000200930202000300E00202000400E40202000500F00202000600D402000001007404000002007E04000003008804000004009104000005009D0400000600A60400000700B20400000800BC0400000900C80400000100EA0302000200D40402000300DD0402000400E00402000500E30402000600E60402000700E90402000800EC0402000900EF0402000A00F20402000B00F50402000C00F80402000D00FB0402000E00FE0402000F000105020010000405020011000705020012000A05020013000D05020014001005020015001305020016001605020017001905020018001C05020019001F0502001A00220502001B00250502001C00280502001D002B0502001E002E0502001F003105020020003405000001003705000002001A04000003004605000001004E05000001005405000002005805000003005E0500000100670500000200700500000100460500000100A70800000100A70800000100A70800000100A70800000100A70800000100A70800000100A708030009000A0006000A0011000A0009000B000A000B0095000B000E000B0011000B0009000C0006000C0011000C0009000D0006000D0011000D0009000E000A000E0095000E000E000E0011000E0009000F0006000F0011000F00090010000600100011001000090011008B02F30069003B02F30071003B02550179003B02550181003B02550189003B02550191003B02550199003B025501A1003B025501A9003B025501B1003B025501B9003B02FB00C1003B025501C9003B025501D1003B025501D9003B025A01E9003B026001F9003B02660101013B02F30009013B02F300210018089B010C007008A6012100A108F30021007008A20119013B02F30021013B02F30009003B02F30029007009C4010900C903480131007009CA011400E309EB012901E309F5011C007008A60131012F0B06023101410B0C0239015C0B21023901680B26023901730B2C0239017B0B0C023901860B31024101950B360239019D0B3B023901A40B48014901B80B41024901C90B41025101EC0B460261003B02F30069013B02550169017B0BA8026101B40CAC026101C30CB6027901EE0CBD026100F30CCA0261007B0B0C026100FA0C660161018B02F3004100ED0D17039901170E1D03A1013B022403A1012D0E2A03A901390E300399013E0EF30049003B023E033901A50E5503C101670F9A03B1016E0F6601B1018F0F6601C901CD0FA103C101E40FA703C1010010AE03D9010C10A802D9011E104801D9013510B403E101EE0CBA03D9014710F30031006F109B01E9013B02F300F101A31019043100AC1048013901B6101F043901B6102504F901BD10550159003B0255010102E210F30009028B02F30011023B023B0461003B02550139012811420451003411FC03290034113A0139013F114804610047114E0431003411180161009D0B56046100F30C5D0429006F109B012900AC10A8022902C903480129003B027D0431023B02F30039023B02F3002000A3006B0127002B03B4012E007B004E052E00930064052E009B006D052E005300FA042E006300FA042E006B0024052E004B0000052E002300EE042E008B005B052E001B0088042E003300FA042E004300EE042E002B00FA042E003B00FA048000A3007102C000A300E6024001A300660343012303B40163012303B4018001A300CE0383012303B401A3012303B401C0016B02B401C3012303B401E3012303B40103022303B4018003CB00B401A003CB00B401E003CB00B4010004CB00B4012004CB00B4014004CB00B4018004CB00B401A004CB00B401E004CB00B4010005CB00B4016005CB00B4018005CB00B401C005CB00B401E005CB00B4016006CB00B4018006CB00B401C006CB00B401E006CB00B4014007CB00B4016007CB00B401A007CB00B401C007CB00B4010008CB00B4012008CB00B4018008CB00B401A008CB00B401E008CB00B4010009CB00B4016009CB00B4018009CB00B401C009CB00B401E009CB00B401080006008C05AF01B901BD01D00110021C0253025A025E0263026702D002D602DA02E10210033903440349035C03C203C90304040D0414042B0463046A04730477048204090001000A0002000B0004000C0006000D0008000E000A000F000C0010000E000000E40351010000DD08AB0100001B09AB010000D90A020200001B09AB010000DD08AB0100001B09AB010000DD08AB0100001B09AB010000D90A020200001B09AB010000DD08AB0100001B09AB010000DD08AB0100001B09AB0102001800030002001C00050002001F000700020024000900020027000B0002002B000D0002002E000F0002003300110002003600130002003D001500020040001700020044001900020047001B0002004B001D0002004E001F000300240003000A0038002D000A0036002B000A003A002F000A003C0003000A003E0031000B0046002B000B00440041000B0042003F000B00480043000B004A002F000B004C0003000B004E0031000C0054002B000C0056002D000C0058002F000C005A0003000C005C0031000D0066002D000D0064002B000D0068002F000D006A0003000D006C0031000E00800031000E00760041000E0078002B000E007A0043000E007C002F000E007E0003000E0074003F000F0088002D000F0086002B000F008A002F000F008C0003000F008E003100100094002B00100096002D00100098002F0010009A00030010009C0031009401D501DB01048000000100000000000000000000000000C207000004000000000000000000000001008500000000000400000000000000000000000100DC0000000000040000000000000000000000010079010000000004000000000000000000000001008E0000000000030002000400020005000200060002000700020008000200090002000A0002000B0002000C0002000D0002000E0002000F000200100002006900C6020000003C4D6F64756C653E006269676F726D2E646C6C004171756972650053716C436F6E74657874436F6E6E656374696F6E005A65726F546F4E696E655F526F770052617746696C65535F526F770052617746696C655F526F7700487474704765745F526F7700476F6F676C65416E616C79746963735F526F77004578515F4F7074696F6E73006D73636F726C69620053797374656D004F626A6563740049446973706F7361626C650056616C7565547970650053797374656D2E436F6C6C656374696F6E730049456E756D657261746F72005A65726F546F4E696E650053797374656D2E446174610053797374656D2E446174612E53716C54797065730053716C496E7436340053716C537472696E67005A65726F546F4E696E655F46696C6C0053797374656D2E436F6C6C656374696F6E732E47656E657269630049456E756D657261626C6560310046696C655F46696C654F7246696C65730052617746696C65530052617746696C65535F46696C6C0052617746696C650053797374656D2E436F72650053797374656D2E494F2E4D656D6F72794D617070656446696C6573004D656D6F72794D6170706564566965774163636573736F720052617746696C655F436F7079446174610053716C42696E6172790052617746696C655F46696C6C00487474705F5572694F7255726973004874747047657400487474704765745F46696C6C0053716C4461746554696D6500476F6F676C65416E616C797469637300476F6F676C65416E616C79746963735F46696C6C00457851002E63746F720053797374656D2E446174612E53716C436C69656E740053716C436F6E6E656374696F6E00636F6E6E656374696F6E0053797374656D2E49446973706F7361626C652E446973706F736500446973706F736500706B0053797374656D2E5465787400537472696E674275696C646572006E616D6500636F6D6D656E74006C656E67746800666E007374720066696C654E616D650062006D61784C656E6774680075726900636F6E74656E745479706500636F6E74656E744C656E67746800734F7574436F6D6D656E7400644F75744100694F75744100734F75744100736C44696D656E73696F6E4E616D657300736C4D65747269634E616D657300664300496E6974006F76657277726974650073706C697451756572794F6E53656D69636F6C6F6E0072657175727365466F72526F7773496E517565727900736176655072696E744F757470757400646F6E74536176655265636F72644F7574707574007072696E744465736372697074696F6E006F726967696E616C4F7074696F6E73006765745F557361676500546F537472696E6700576974686F757453706C6974517565727900557361676500726F770053797374656D2E52756E74696D652E496E7465726F705365727669636573004F75744174747269627574650066696C654F7246696C65730066696C654E616D6573006F6666736574006275666665724C656E67746800627566666572436F756E74006163636573736F72007572694F725572697300636F6E74656E744D61784C656E6774680073557365726E616D65007350617373776F7264007350726F66696C65007344696D656E73696F6E7300734D657472696373006474537461727444617465006474456E644461746500695374617274496E64657800694D6178526573756C74730073436F6D6D656E740073300069300064300073310069310064310073320069320064320073330069330064330073340069340064340073350069350064350073360069360064360073370069370064370073380069380064380073390069390064390071756572794F7251756572696573006F7074696F6E7300624F70656E005F706B005F6E616D65005F636F6D6D656E74005F636F6D6D616E640073446174610053797374656D2E52756E74696D652E56657273696F6E696E67005461726765744672616D65776F726B4174747269627574650053797374656D2E5265666C656374696F6E00417373656D626C795469746C6541747472696275746500417373656D626C794465736372697074696F6E41747472696275746500417373656D626C79436F6E66696775726174696F6E41747472696275746500417373656D626C79436F6D70616E7941747472696275746500417373656D626C7950726F6475637441747472696275746500417373656D626C79436F7079726967687441747472696275746500417373656D626C7954726164656D61726B41747472696275746500417373656D626C7943756C7475726541747472696275746500436F6D56697369626C65417474726962757465004775696441747472696275746500417373656D626C7956657273696F6E41747472696275746500417373656D626C7946696C6556657273696F6E4174747269627574650053797374656D2E53656375726974792E5065726D697373696F6E730053656375726974795065726D697373696F6E417474726962757465005365637572697479416374696F6E0053797374656D2E446961676E6F73746963730044656275676761626C6541747472696275746500446562756767696E674D6F6465730053797374656D2E52756E74696D652E436F6D70696C6572536572766963657300436F6D70696C6174696F6E52656C61786174696F6E734174747269627574650052756E74696D65436F6D7061746962696C697479417474726962757465006269676F726D004D6963726F736F66742E53716C5365727665722E5365727665720053716C46756E6374696F6E417474726962757465003C5A65726F546F4E696E653E645F5F300049456E756D657261746F726031004D6F76654E657874003C3E325F5F63757272656E740053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E6765745F43757272656E74006765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E5265736574005265736574003C3E315F5F73746174650053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E6765745F43757272656E740053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E4F626A6563743E2E43757272656E740053797374656D2E436F6C6C656374696F6E732E49456E756D657261746F722E43757272656E7400446562756767657248696464656E417474726962757465004E6F74537570706F72746564457863657074696F6E006F705F496D706C69636974003C46696C655F46696C654F7246696C65733E645F5F320049456E756D657261626C650053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261626C653C53797374656D2E537472696E673E2E476574456E756D657261746F7200476574456E756D657261746F720053797374656D2E436F6C6C656374696F6E732E49456E756D657261626C652E476574456E756D657261746F720053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E537472696E673E2E6765745F43757272656E74003C3E6C5F5F696E697469616C5468726561644964003C3E335F5F66696C654F7246696C6573003C625265637572736976653E355F5F33003C73506174683E355F5F34003C735365617263685061747465726E3E355F5F35003C733E355F5F36003C3E375F5F7772617037003C3E6D5F5F46696E616C6C79380053797374656D2E436F6C6C656374696F6E732E47656E657269632E49456E756D657261746F723C53797374656D2E537472696E673E2E43757272656E740053797374656D2E546872656164696E6700546872656164006765745F43757272656E74546872656164006765745F4D616E61676564546872656164496400537472696E6700546F43686172417272617900496E6465784F66416E7900496E6465784F66006765745F4C656E677468006765745F4368617273004368617200546F4C6F7765720052656D6F7665005472696D0053797374656D2E494F0050617468004765744469726563746F72794E616D650047657446696C654E616D65004469726563746F7279005365617263684F7074696F6E00456E756D657261746546696C6573003C52617746696C65533E645F5F62003C726F773E355F5F63003C666E3E355F5F64003C6C456E643E355F5F65004D656D6F72794D617070656446696C65003C6D6D663E355F5F66003C6C4C6F63616C53746172743E355F5F3130003C6163636573736F723E355F5F3131003C623E355F5F3132003C693E355F5F3133003C3E375F5F777261703134003C3E6D5F5F46696E616C6C793135003C3E6D5F5F46696E616C6C7931360046696C65496E666F0046696C654D6F64650043726561746546726F6D46696C6500437265617465566965774163636573736F7200556E6D616E616765644D656D6F72794163636573736F72005265616400417070656E64007365745F4C656E67746800457863657074696F6E003C52617746696C653E645F5F3138003C726F773E355F5F3139003C7346696C654E616D653E355F5F3161003C6C456E643E355F5F3162003C6D6D663E355F5F3163003C6C4C6F63616C53746172743E355F5F3164003C627566666572496E6465783E355F5F3165003C6163636573736F723E355F5F3166003C3E375F5F777261703230003C3E6D5F5F46696E616C6C793231003C3E6D5F5F46696E616C6C7932320042797465004D6963726F736F66742E57696E33322E5361666548616E646C657300536166654D656D6F72794D61707065645669657748616E646C65006765745F536166654D656D6F72794D61707065645669657748616E646C6500536166654275666665720041637175697265506F696E74657200496E7450747200416464004D61727368616C00436F70790052656C65617365506F696E746572003C487474705F5572694F72557269733E645F5F3234003C3E335F5F7572694F7255726973003C735572693E355F5F3235003C3E6D5F5F46696E616C6C793236003C3E375F5F777261703237003C3E375F5F7772617032380053706C6974003C487474704765743E645F5F3262003C726F773E355F5F3263003C735572693E355F5F32640053797374656D2E4E6574004874747057656252657175657374003C726571756573743E355F5F32650048747470576562526573706F6E7365003C726573706F6E73653E355F5F3266003C623E355F5F3330003C69546F74456E643E355F5F3331003C694E65774C656E3E355F5F3332003C3E375F5F777261703333003C3E6D5F5F46696E616C6C793334005765625265717565737400437265617465007365745F4D6178696D756D4175746F6D617469635265646972656374696F6E73007365745F4D6178696D756D526573706F6E7365486561646572734C656E6774680043726564656E7469616C4361636865004943726564656E7469616C73006765745F44656661756C7443726564656E7469616C73007365745F43726564656E7469616C7300576562526573706F6E736500476574526573706F6E7365006765745F436F6E74656E744C656E677468006765745F436F6E74656E74547970650053747265616D00476574526573706F6E736553747265616D00436C6F7365003C476F6F676C65416E616C79746963733E645F5F3336003C726F773E355F5F3337006765745F49734E756C6C0053716C50726F6365647572654174747269627574650053716C436F6E746578740053716C50697065006765745F50697065006765745F56616C756500436F6E6361740053656E640053797374656D2E446174612E436F6D6D6F6E004462436F6E6E656374696F6E004F70656E0053797374656D2E436F6D706F6E656E744D6F64656C00436F6D706F6E656E74005374727563744C61796F7574417474726962757465004C61796F75744B696E64006F705F457175616C697479004E756C6C00496E743332005265706C61636500417070656E64466F726D6174002E6363746F7200426F6F6C65616E00436F6D70696C657247656E6572617465644174747269627574650053797374656D2E536563757269747900556E76657269666961626C65436F64654174747269627574650000095A00650072006F0000595700650020006F006600740065006E00200073007400610072007400200063006F0075006E00740069006E00670020006100740020007A00650072006F0020006F006E00200063006F006D0070007500740065007200730000074F006E006500001532006E00640020006E0075006D006200650072000007540077006F000007330072006400000B540068007200650065000007340074006800000946006F007500720000394600690066007400680020006E0075006D006200650072002C002000680061006C006600200077006100790020007400680065007200650000094600690076006500000B530069007800740068000007530069007800000F53006500760065006E0074006800000B53006500760065006E00000B45006900670068007400000D4E0069006E0065007400680000094E0069006E00650000215400680065002000740065006E007400680020006E0075006D0062006500720000072F003F002A0000070A000D00090000116400650073006300720069006200650000434500780065006300750074006500200061006E00640020007300610076006500200072006500730075006C00740073000A000900510075006500720079003A00200000050A0009000013460069006C0065002800730029003A00200000154E006F002000660069006C00650028007300290000170A0009004F007000740069006F006E0073003A002000003F54004F0044004F003A0020005200650063007500720073006500200066006F007200200072006F0077007300200069006E00200071007500650072007900002F63006F006E007400650078007400200063006F006E006E0065006300740069006F006E003D00740072007500650000037C0000454300520045004100540045002000560049004500570020004D00790056006900650077004E0061006D0065002000410053000A00530045004C0045004300540020002000001D0A00090073007B0030007D0020004100530020007B0031007D002C000007670061003A00000B7300440069006D005F00001969007B0030007D0020004100530020007B0031007D002C00000B6900440069006D005F00001964007B0030007D0020004100530020007B0031007D002C00000B6400440069006D005F00001373004D006500610073007500720065005F00001369004D006500610073007500720065005F00001364004D006500610073007500720065005F00003F0A00460052004F004D00200047006F0072006D002E0047006F006F0067006C00650041006E0061006C007900740069006300730028002E002E002E0029000082C9550073006100670065003A00200045007800510020004000710075006500720079004F007200510075006500720069006500730020004E00560041005200430048004100520028004D004100580029002C0020004000660069006C0065004F007200460069006C006500730020004E00560041005200430048004100520028004D004100580029002C00200040006F007000740069006F006E007300200049004E0054000A0009004000710075006500720079004F0072005100750065007200690065007300090051007500650072007900200028004E0055004C004C00200066006F0072002000740068006900730020006D0065007300730061006700650029000A0009004000660069006C0065004F007200460069006C00650073000900440065007300740069006E006100740069006F006E000A00090040006F007000740069006F006E00730009000A0009000900310009004F00760065007200770072006900740065002000640065007300740069006E006100740069006F006E000A000900090032000900530070006C006900740020006F006E00200027003B0027000A0009000900340009005200650063007500720073006500200066006F007200200072006F0077007300200069006E00200071007500650072007900200028006600690072007300740020007400680072006500650020006600690065006C006400730029000A0009000900380009005300610076006500200022005000520049004E005400220020006F00750074007000750074000A000900090031003600090044006F006E00270074002000730061007600650020007200650063006F007200640073006500740020006F00750074007000750074000A00090009003300320009005000520049004E0054002000640065007300630072006900700074006F006E00730020006F00660020007700680061007400200069007300200064006F006E00650001154F00760065007200770072006900740065003A0000312C002000730070006C0069007400510075006500720079004F006E00530065006D00690063006F006C006F006E003A0000312C002000720065007100750072007300650046006F00720052006F007700730049006E00510075006500720079003A0000252C00200073006100760065005000720069006E0074004F00750074007000750074003A00002F2C00200064006F006E00740053006100760065005200650063006F00720064004F00750074007000750074003A0000272C0020007000720069006E0074004400650073006300720069007000740069006F006E003A00008A329BF543EDA244B8B5969CB0BFEE6B0008B77A5C561934E08904000012110D0004011C10111510111910111908000115121D010E0E08000412110E0A0A0A0A0004011C100A100E100E08000412110E0A080A090003011011181221080B0004011C100A100E10112506000212110E080F0006011C100A100E100E10081011251600091211111911191119111911191129112911151115610020011C10111910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112910111910111510112909000301111911191115032000010306122D042001010202060A03061231062003010A0E0E02060E03061D050206080306111904061D112904061D111504061D111903061D0E072002010E1D1119020602030611150520010111150300000E0320000E04200011150308000E042001010E05200101117105200101117904200101082801000100540E1146696C6C526F774D6574686F644E616D650F5A65726F546F4E696E655F46696C6C0615128089011C0320000202061C0320001C04200013000328001C040702020804010000000307011C0607021228121105000111150A05000111190E04070111100515121D010E0615128089010E08200015128089010E092000151280890113000420001211070615128089010E0328000E050000128099032000080B0703122C15128089010E0204070112110420001D03052001081D030420010803042001030804000103030520020E08080400010E0E0C000315121D010E0E0E1180AD060704080208020307010E040702080803070102090702122C15121D010E2601000100540E1146696C6C526F774D6574686F644E616D650D52617746696C65535F46696C6C0306111404061280B1030612210206050320000A0900021280B10E1180B906200212210A0A08300102010A101E00030A0105052001123103050703020802030701080607021230121104070111142501000100540E1146696C6C526F774D6574686F644E616D650C52617746696C655F46696C6C03061118060702123412110520001280C906200101100F05052001010F0105000218180808000401181D0508080407010F05052001011D0504070111180B0703123815128089010E020620011D0E1D03090702123815121D010E2501000100540E1146696C6C526F774D6574686F644E616D650C487474704765745F46696C6C0306111C04061280D904061280DD0600011280E10E0500001280E9062001011280E90520001280ED0520001280F1072003081D050808060702123C1211040701111C2D01000100540E1146696C6C526F774D6574686F644E616D6514476F6F676C65416E616C79746963735F46696C6C03061129030611200807040208021D11190607021240121104070111200500001280FD0500020E0E0E0500010E1D0E0F07081224120C0E021D0E1D031D0E080620010111810D050002020E0E0520020E0E0E07200312310E1C1C0620021231080805200112310E060703123108020407020802030000010307010A0507020E1D0E042001010A050702111502650100292E4E45544672616D65776F726B2C56657273696F6E3D76342E302C50726F66696C653D436C69656E740100540E144672616D65776F726B446973706C61794E616D651F2E4E4554204672616D65776F726B203420436C69656E742050726F66696C650B0100066269676F726D00000501000000002301001E436F7079726967687420C2A9476F726D204272616172766967203230313400002901002466323039323162352D616334332D343032622D386662352D37323962613164636434626600000C010007312E302E302E3000000801000701000000000801000800000000001E01000100540216577261704E6F6E457863657074696F6E5468726F777301809E2E01808453797374656D2E53656375726974792E5065726D697373696F6E732E53656375726974795065726D697373696F6E4174747269627574652C206D73636F726C69622C2056657273696F6E3D342E302E302E302C2043756C747572653D6E65757472616C2C205075626C69634B6579546F6B656E3D623737613563353631393334653038391501540210536B6970566572696669636174696F6E0100000000F031FE5200000000020000001C010000F4760000F45800005253445359A103354CF53641BE8B2961B052615C02000000633A5C5F637573746F6D65725F706172746E65725C6269676F726D5C6269676F726D5C6F626A5C44656275675C6269676F726D2E706462000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000003878000000000000000000004E780000002000000000000000000000000000000000000000000000407800000000000000005F436F72446C6C4D61696E006D73636F7265652E646C6C0000000000FF25002000100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000100100000001800008000000000000000000000000000000100010000003000008000000000000000000000000000000100000000004800000058800000B80200000000000000000000B80234000000560053005F00560045005200530049004F004E005F0049004E0046004F0000000000BD04EFFE00000100000001000000000000000100000000003F000000000000000400000002000000000000000000000000000000440000000100560061007200460069006C00650049006E0066006F00000000002400040000005400720061006E0073006C006100740069006F006E00000000000000B00418020000010053007400720069006E006700460069006C00650049006E0066006F000000F40100000100300030003000300030003400620030000000380007000100460069006C0065004400650073006300720069007000740069006F006E00000000006200690067006F0072006D0000000000300008000100460069006C006500560065007200730069006F006E000000000031002E0030002E0030002E003000000038000B00010049006E007400650072006E0061006C004E0061006D00650000006200690067006F0072006D002E0064006C006C000000000060001E0001004C006500670061006C0043006F007000790072006900670068007400000043006F0070007900720069006700680074002000A90047006F0072006D0020004200720061006100720076006900670020003200300031003400000040000B0001004F0072006900670069006E0061006C00460069006C0065006E0061006D00650000006200690067006F0072006D002E0064006C006C0000000000300007000100500072006F0064007500630074004E0061006D006500000000006200690067006F0072006D0000000000340008000100500072006F006400750063007400560065007200730069006F006E00000031002E0030002E0030002E003000000038000800010041007300730065006D0062006C0079002000560065007200730069006F006E00000031002E0030002E0030002E0030000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000007000000C000000603800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
WITH PERMISSION_SET=UNSAFE
GO--
CREATE FUNCTION bigorm.ZeroToNine() RETURNS TABLE (PK BIGINT, Name NVARCHAR(4000), Description NVARCHAR(MAX)) EXTERNAL NAME bigorm.Aquire.ZeroToNine
GO--
	CREATE VIEW bigorm_test.ZeroToNine AS SELECT TOP 3 * FROM bigorm.bigorm.ZeroToNine()
GO
CREATE FUNCTION bigorm.GoogleAnalytics(@UserName NVARCHAR(MAX),@Password NVARCHAR(MAX),@Profile NVARCHAR(MAX),@Dimensions NVARCHAR(MAX),@Metrics NVARCHAR(MAX),@StartDate DATETIME,@EndDate DATETIME,@StartIndex BIGINT,@MaxResults BIGINT) RETURNS TABLE (comment NVARCHAR(MAX),s0 NVARCHAR(MAX),i0 BIGINT,d0 DATETIME,s1 NVARCHAR(MAX),i1 BIGINT,d1 DATETIME,s2 NVARCHAR(MAX),i2 BIGINT,d2 DATETIME,s3 NVARCHAR(MAX),i3 BIGINT,d3 DATETIME,s4 NVARCHAR(MAX),i4 BIGINT,d4 DATETIME,s5 NVARCHAR(MAX),i5 BIGINT,d5 DATETIME,s6 NVARCHAR(MAX),i6 BIGINT,d6 DATETIME,s7 NVARCHAR(MAX),i7 BIGINT,d7 DATETIME,s8 NVARCHAR(MAX),i8 BIGINT,d8 DATETIME,s9 NVARCHAR(MAX),i9 BIGINT,d9 DATETIME) EXTERNAL NAME bigorm.Aquire.GoogleAnalytics
GO--
	CREATE VIEW bigorm_test.GoogleAnalytics AS SELECT * FROM bigorm.GoogleAnalytics(NULL,NULL,NULL,'ga:date','ga:pageviews|ga:pageviewsPerVisit|ga:timeOnSite|ga:totalValue|ga:visitors',NULL,NULL,NULL,NULL)
GO
CREATE FUNCTION bigorm.RawFileS(@FileName NVARCHAR(MAX), @Offset BIGINT, @Length BIGINT, @BufferLength BIGINT) RETURNS TABLE (PK BIGINT, FileName NVARCHAR(4000), Content NVARCHAR(MAX)) EXTERNAL NAME bigorm.Aquire.RawFileS
GO--
	CREATE VIEW bigorm_test.RawFileS AS SELECT TOP 3 * FROM bigorm.bigorm.RawFileS('C:\Windows\Logs\DirectX.log',0,-1,100)--SELECT TOP 100 * FROM bigorm.bigorm.RawFileS('C:\Windows\Logs\*.*',0,-1,1024*1024) WHERE Content='10/19/13 16:24:20: dsetup32: === SetupForDirectX() start ==='
GO
CREATE FUNCTION bigorm.RawFile(@FileName NVARCHAR(MAX), @Offset BIGINT, @BufferLength INT, @BufferCount BIGINT) RETURNS TABLE (PK BIGINT, FileName NVARCHAR(4000), Content VARBINARY(MAX)) EXTERNAL NAME bigorm.Aquire.RawFile
GO--
	CREATE VIEW bigorm_test.RawFile AS WITH t AS (SELECT PK, fileName, cs=CHECKSUM(Content), length=LEN(Content) FROM bigorm.bigorm.RawFile('C:\Windows\logs\*.* /s',0,1024*1024,1024*1024*1024)) SELECT len=SUM(length), chcks=CHECKSUM_AGG(cs) FROM t--SELECT *,CAST(Content AS NVARCHAR(MAX)),CAST(Content AS VARCHAR(MAX)) FROM bigorm.bigorm.RawFile('C:\Windows\Logs\*.log',0,0,1) UNION ALL SELECT *,CAST(Content AS NVARCHAR(MAX)),CAST(Content AS VARCHAR(MAX)) FROM bigorm.bigorm.RawFile('C:\Windows\Logs\DirectX.log',0,0,1)--SELECT PK, fileName, length=LEN(Content) FROM bigorm.bigorm.RawFile('e:\_priv\*.* /s',0,1024*1024*1024,1)--SELECT SUM(CAST(CHECKSUM(Content) AS BIGINT)) FROM bigorm.bigorm.RawFile('C:\inetpub\logs\LogFiles\*.* /s',0,1024*1024*128,1024*1024)
GO
CREATE FUNCTION bigorm.HttpGet(@UriOrUris NVARCHAR(MAX), @maxLength INT) RETURNS TABLE (PK BIGINT, Uri NVARCHAR(MAX), ContentType NVARCHAR(4000), ContentLength INT, Content VARBINARY(MAX)) EXTERNAL NAME bigorm.Aquire.HttpGet
GO--
	CREATE VIEW bigorm_test.HttpGet AS SELECT *,ContentText=CAST(Content AS VARCHAR(MAX)) FROM bigorm.bigorm.HttpGet('https://www.google.com/?q=Gorm%20Braarvig#q=Gorm+Braarvig',100*1024*1024)--SELECT *,txt=CAST(Content AS VARCHAR(MAX)),l=LEN(Content) INTO #t FROM bigorm.bigorm.HttpGet('http://en.wikipedia.org/wiki/ISO_3166-1_alpha-2',100*1024*1024)
GO
CREATE PROCEDURE bigorm.ExQ @queryOrQueries NVARCHAR(MAX), @fileOrFiles NVARCHAR(MAX), @options BIGINT=NULL AS EXTERNAL NAME bigorm.Aquire.ExQ
GO--
	CREATE PROC bigorm_test.ExQ AS EXEC bigorm.bigorm.ExQ NULL, NULL
GO
PRINT 'Test' --SELECT *,LEN(Content) FROM bigorm.bigorm.HttpGet('https://www.google.com/?q=Gorm%20Braarvig#q=Gorm+Braarvig	https://www.google.com/?q=Jane%20Doe#q=Jane+Doe',1024*1024)--SELECT CAST(Content AS VARCHAR(MAX)) FROM bigorm.bigorm.HttpGet('https://www.google.com/?q=Gorm%20Braarvig#q=Gorm+Braarvig',1024*1024)
GO
CREATE PROC bigorm_test.Creation AS
	SELECT Description='Count', Why='To test that CLR TVF can be made'
	SELECT * FROM bigorm_test.ZeroToNine
	SELECT Description='Google analytics', Why='To test that reading from google analytics is possible'
	SELECT * FROM bigorm_test.GoogleAnalytics
	SELECT Description='Text file read', Why='To read text files'
	SELECT * FROM bigorm_test.RawFileS
	SELECT Description='Raw file read', Why='To read using memory mapped files'
	SELECT * FROM bigorm_test.RawFile
	SELECT Description='HTTP get', Why='To read web page'
	SELECT * FROM bigorm_test.HttpGet
	EXEC bigorm_test.ExQ
GO
EXEC bigorm_test.Creation
